|
Mr Wendel 4:42 Mon Feb 8
Maths Question
|
If I am buying something for 30p and selling it for 47p what is the formula to know what margin percentage I am making.
On Excel, if the cost is in D2 and the Sale is in E2 - what is the formula.
Help would be much appreciated.
Mr W. |
|
Replies - Newest Posts First (Show In Chronological Order)
Big Dave 10:31 Tue Feb 9
Re: Maths Question
|
I'd be happy with a 56% profit margin. |
|
plaistowhammer1 9:09 Tue Feb 9
Re: Maths Question
|
To be honest mate if yourbuying something for 30p and selling it for 47p your waisting you fucking time. |
|
Raul Duke 3:59 Tue Feb 9
Re: Maths Question
|
As no doubt everyone on this thread has intoned, your margin here is the difference between buying and selling price, divided by your buying price and multiplied by 100:
(47-30)/30*100
West Ham maths club solves your problems. |
|
gph 3:33 Tue Feb 9
Re: Maths Question
|
By an amazing coincidence, this also works with sqrt(295) + 39i. |
|
SecondOpinion 7:50 Mon Feb 8
Re: Maths Question
|
Ok..................think of a number between 1-100.
Double it (x2)
Add 27
Divide by 2
Take off the first number you thought of
The answer is 13.5 |
|
McD 5:24 Mon Feb 8
Re: Maths Question
|
Mr Wendel, are you sure you are qualified to do your job?
swt |
|
busheyhammer85 5:20 Mon Feb 8
Re: Maths Question
|
Format the SUM cell to percentage. |
|
busheyhammer85 5:19 Mon Feb 8
Re: Maths Question
|
Sorry that should be
(E2-D2)/D2
= 56.67% |
|
charleyfarley 5:16 Mon Feb 8
Re: Maths Question
|
( Hca ) s ctions ari 3n , o ever, eo ' to, 1 e o er , ' e ' tion + = is ' on ... us, takes the form G 3 hpI + i+ h2JPg + a , e +2n 2 1 n1 ho hl h2 l 1 1 i 1 ... 1 1 1 x G4 Were . (61, therdiii, , 42 i ho A Z I d A2 Al ho maftim of C t 4 ..
where of course, G is your profit margin |
|
:^) 5:13 Mon Feb 8
Re: Maths Question
|
lol's at nag too. |
|
:^) 5:12 Mon Feb 8
Re: Maths Question
|
gph 4:59 Mon Feb 8
heh heh |
|
NotAGooner 5:09 Mon Feb 8
Re: Maths Question
|
and Repka |
|
NotAGooner 4:59 Mon Feb 8
Re: Maths Question
|
I blame the cat |
|
gph 4:59 Mon Feb 8
Re: Maths Question
|
Schr:^)dinger |
|
:^) 4:55 Mon Feb 8
Re: Maths Question
|
¯h2. 2m. ∇2Ψ(r,t) + V (r,t)Ψ(r,t) = i¯h. ∂Ψ(r,t). ∂t. |
|
McD 4:54 Mon Feb 8
Re: Maths Question
|
E2/D2 - 1 is actually the easiest.
HTH |
|
gph 4:54 Mon Feb 8
Re: Maths Question
|
Send him an invoice, WWW. |
|
NotAGooner 4:53 Mon Feb 8
Re: Maths Question
|
E=Mc2
...or summat |
|
Mr Wendel 4:52 Mon Feb 8
Re: Maths Question
|
Thank you WWW - worked a treat! |
|
|
|
|
